package com.lhkj.ct.meta.admin.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.lhkj.ct.meta.admin.model.entity.TblUserRole;

import java.util.List;

/**
 * <p>
 *      用户和角色关联表 Mapper 接口
 * </p>
 *
 * @author jobob
 * @since 2023-09-04
 */
public interface SysUserRoleMapper extends BaseMapper<TblUserRole> {

    List<String> selectRoleIdsByUser(String userId);

//    @Select("select distinct r.code from tbl_user_role ur inner join tbl_role r on r.id = ur.role_id where ur.user_id = #{userId,jdbcType=VARCHAR} ")
//    Set<String> selectRoleCodesByUser(String userId);
}
